{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Options"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Options","index":0,"n_rows":143,"n_cols":45,"rows_kept":143,"cut":false,"hidden":false,"merged":[[15,4,26,12],[120,4,120,6],[121,4,121,6]]}
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[]
[]
[]
[]
[]
[]
[null,null,"Description  and details of Macro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise:","MTEC",null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count across",{"$f":"COUNTIF(Q11:AS11,\">0\")","v":17}]
[null,null,"Purpose:",null,"Macro to correct formulas on Infra Sheet",null,null,null,null,null,null,null,null,null,null,"Count down",{"$f":"COUNTA(Q13:Q307)","v":6},{"$f":"COUNTA(R13:R305)","v":35},{"$f":"COUNTA(S13:S293)","v":39},{"$f":"COUNTA(T13:T292)","v":4},{"$f":"COUNTA(U13:U291)","v":18},{"$f":"COUNTA(V13:V292)","v":1},{"$f":"COUNTA(W13:W306)","v":12},{"$f":"COUNTA(X13:X306)","v":20},{"$f":"COUNTA(Y13:Y297)","v":15},{"$f":"COUNTA(Z13:Z306)","v":1},{"$f":"COUNTA(AA13:AA304)","v":2},{"$f":"COUNTA(AB13:AB306)","v":8},{"$f":"COUNTA(AC13:AC306)","v":8},{"$f":"COUNTA(AD13:AD306)","v":1},{"$f":"COUNTA(AE13:AE307)","v":4},{"$f":"COUNTA(AF13:AF306)","v":4},1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sheets:",null,"InfraS 1.1 & InfraS 1.2",null,null,null,null,null,null,null,null,null,null,"Sheet No./Name","Summary","Prog","Sprog","Function shift","Func Shifts - Desc","Reprioritisation","Personnel","Receipts","InfraS ","ODA Summary","2013 ENE","Deviations","Expend trends","Dept specific info","Training","PPP Projects","Dept specific info - own",19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,"Applicable to:",null,null,null,null,null,null,null,null,null,null,null,null,"Area:","G8:J9","G9","G302:H302","G15:N16","G113","F14:Z113","G68:J84","H14:O14","G12:T161","F14:W267","G43:J57","K14","G14:I28","F14:M1013","G15:M15","H50:L50","A1:CA10000"]
[null,null,"Date of macro:",null,"17/11/2016",null,null,null,null,null,null,null,null,null,null,null,"F12:Q12","K9:M9","K302:M302","P15:R16","G115",null,"L68:M84","F18:F22","W12:X161",null,"G59:J59","O15:Q17","K14:K28",null,"G16:I16","H58:L60"]
[null,null,"Effective until:",null,null,null,null,null,null,null,null,null,null,null,null,null,"F31:F45","F12:T12","F305:T305","F18:F47","G121:N123",null,"O68:P84","H18:O22","AB12:AC161",null,null,"K18","G31:I35",null,"G18:J24","H63:L67"]
[null,null,"More Information:",null,"This macro will make the following adjustments to the model:\nCorrect formulas on InfraS 1.1 & InfraS 1.2 \n\n\nTo make sure that all calculations are updated, do the following:\n\nAfter running the (ENE) macro. SAVE THE FILE!",null,null,null,null,null,null,null,null,null,null,null,"AW31:AW45","F16:W35","F310:G319",null,"P121:R123",null,"R68:S84","F24:F28","AG12:AH161",null,null,"O19:Q25","K31:K35",null,"K23:M23","H72:L80"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AW48:AW52","F47:F71","I310:Y319",null,"G125:N126",null,"U68:V84","H24:O28","AL12:AQ161",null,null,"K26","G44:I46"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G47:G71","AD310:AH319",null,"P125:R126",null,"X68:X84","F30:F34","G164:T313",null,null,"O27:Q34","G48:I54"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I160:Q160","AM310:AN319",null,"G129:N130",null,"L85","H30:O34","W164:X313",null,null,"K34","G56:I62"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S160","F326:G334",null,"P129:R130",null,"O85","F36:F40","AB164:AC313",null,null,"O38:Q38","G63:I63"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U160:W160","I326:Q335",null,"G132:N135",null,"R85","H36:O40","AG164:AH313"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD160:AF160","S326:S335",null,"P132:R135",null,"U85","H42:O47","AL164:AQ313"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM160:AO160","U326:W335",null,"G137:N139",null,"X85","H49:O51","G316:T465"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F177:G246","AD326:AF335",null,"P137:R139",null,null,"H53:O53","W316:X465"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I177:Q246","AM326:AO335",null,"G141:N142",null,null,"F55:F59","AB316:AC465"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S177:S246","I340:Q341",null,"P141:R142",null,null,"H55:O60","AG316:AH465"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U177:W246","S340:S341",null,"G145:N146",null,null,"H62:O63","AL316:AQ465"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD177:AF246","U340:W341",null,"P145:R146",null,null,"H66:O68"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM177:AO246","AD340:AF341",null,"G148:N155",null,null,"F72:F81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AW177:BB246","AM340:AO341",null,"P148:R155",null,null,"H72:O81"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F248:G261","I343:Q380",null,null,null,null,"F83:F92"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I248:Q261","S343:S380",null,null,null,null,"H83:O92"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S248:S261","U343:W380"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U248:W261","AD343:AF380"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD248:AF261","AM343:AO380"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM248:AO261","I382:Q383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AX248:BB261","S382:S383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F269:F281","U382:W383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I269:Q281","AD382:AF383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S269:S281","AM382:AO383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U269:W281","I410:Q411"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD269:AF281","S410:S411"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM269:AO281","U410:W411"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AW269:AZ281","AD410:AF411"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F287:G296","AM410:AO411"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J287:N296","I413:Q419"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S413:S419"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U413:W419"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AD413:AF419"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM413:AO419"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Checks"]
[null,null,null,null,"Over / (under) Programme total less Economic classification total",null,null,0,0,null,0.33348995447158813,null,0,0]
[null,null,null,null,"Over / (under) Column H row 115 not equal to Adjusted Appropriation reflected in ENE 2015.",null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,0]